package com.kingschan.jeasytag.sql.query;

import java.sql.Connection;
import java.util.List;

/**
 * <pre>
 * @author kingschan
 * date:2012-11-27
 * description:
 * </pre>
 */
public interface Query {
	/**
	 * paginationQuery
	 * @param con  
	 * @param sql	
	 * @param pageIndex 
	 * @param pagesize 
	 * @param orderByStr  
	 * @param closeConnection 
	 * @param whereStr   
	 * @return
	 * @throws Exception
	 */
	Pagination paginationQuery(
			Connection con,
			String sql,
			int pageIndex,
			int pagesize,
			List<String> orderByStr,
			Boolean closeConnection,
			String whereStr
			)throws Exception;
	/**
	 * @param 
	 * @param 
	 * @param closeConnection 
	 * @return
	 * @throws Exception
	 */
	int getTotalRecordSQL(Connection con,String sql,Boolean closeConnection)throws Exception;
}
